Tabela StockItem

Definicja tabeli StockItem

Name

StockItem

Code

StockItem

Comment

 


Lista kolumn tabeli StockItem

Name

Code

StockItemID

StockItemID

ProducerID

ProducerID

ResourceID

ResourceID

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

Active

Active

StartDT

StartDT

StopDT

StopDT

IsAvailable

IsAvailable

EAN

EAN

PHStItemID

PHStItemID


Kolumna StockItemID tabeli StockItem

Definicja kolumny StockItemID tabeli StockItem

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu


Kolumna ProducerID tabeli StockItem

Definicja kolumny ProducerID tabeli StockItem

Name

ProducerID

Code

ProducerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli StockItem

Definicja kolumny ResourceID tabeli StockItem

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli StockItem

Definicja kolumny Code tabeli StockItem

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli StockItem

Definicja kolumny ShortName tabeli StockItem

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli StockItem

Definicja kolumny FullName tabeli StockItem

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli StockItem

Definicja kolumny Description tabeli StockItem

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Active tabeli StockItem

Definicja kolumny Active tabeli StockItem

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli StockItem

Definicja kolumny StartDT tabeli StockItem

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli StockItem

Definicja kolumny StopDT tabeli StockItem

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna IsAvailable tabeli StockItem

Definicja kolumny IsAvailable tabeli StockItem

Name

IsAvailable

Code

IsAvailable

Data Type

NUMBER(10)

Mandatory

No

Comment

Dostepnosc danego srodka do obrotu w szpitalu


Kolumna EAN tabeli StockItem

Definicja kolumny EAN tabeli StockItem

Name

EAN

Code

EAN

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Kod EAN


Kolumna PHStItemID tabeli StockItem

Definicja kolumny PHStItemID tabeli StockItem

Name

PHStItemID

Code

PHStItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

Mapowanie stockitem w CN na stockitem w aptece.


Lista kluczy tabeli StockItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli StockItem

Definicja klucza Identifier_1 tabeli StockItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment